object DM: TDM
  OldCreateOrder = False
  Left = 252
  Top = 172
  Height = 444
  Width = 651
  object SocketConn: TSocketConnection
    ServerGUID = '{CE2C4A7D-6B08-41FD-A65E-2E7DCB2B02D1}'
    ServerName = 'Server.OCMSServer'
    AfterDisconnect = SocketConnAfterDisconnect
    Left = 24
    Top = 8
  end
  object dsOCHeader: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#20809#32518#22836
    Params = <>
    ProviderName = 'pvOCHeader'
    RemoteServer = SocketConn
    AfterPost = dsOCHeaderAfterPost
    AfterDelete = dsOCHeaderAfterDelete
    OnReconcileError = dsOCHeaderReconcileError
    Left = 24
    Top = 64
  end
  object dsOCTail: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#20809#32518#23614' where '#20809#32518#22836'ID = :OCHeaderID'
    Params = <
      item
        DataType = ftInteger
        Name = 'OCHeaderID'
        ParamType = ptInput
        Value = 0
      end>
    ProviderName = 'pvOCTail'
    RemoteServer = SocketConn
    OnReconcileError = dsOCTailReconcileError
    Left = 104
    Top = 64
  end
  object dsOF: TClientDataSet
    Aggregates = <>
    CommandText = 
      'SELECT '#20809#32420'.'#20809#32420'ID,'#20809#32518#22836'.'#22987#31471#22320#22336' AS '#20809#32518#22987#31471#22320#22336','#20809#32518#23614'.'#32456#31471#22320#22336' AS '#20809#32518#26411#31471#22320#22336','#20809#32420'.'#24207#21495','#20809#32420'.'#29366#24577 +
      ','#20809#32420'.'#25104#31471#24773#20917','#19994#21153'.'#19994#21153#21517#31216','#24320#36890#19994#21153'.'#36335#30001#39034#24207','#35774#22791'.'#22320#22336' As '#22987#31471#35774#22791#22320#22336','#35774#22791'.'#35774#22791#31867#22411','#21333#20803'.'#21333#20803#32534#21495' As '#22987#31471 +
      #35774#22791#21333#20803#21495','#35774#22791#31471#21475'.'#31471#21475#21495' As '#22987#31471#35774#22791#31471#21475#20301#32622','#35774#22791'2.'#22320#22336' As '#32456#31471#35774#22791#22320#22336','#35774#22791'2.'#35774#22791#31867#22411','#21333#20803'2.'#21333#20803#32534#21495' As' +
      ' '#32456#31471#35774#22791#21333#20803#21495','#35774#22791#31471#21475'2.'#31471#21475#21495' As '#32456#31471#35774#22791#31471#21475#20301#32622','#20809#32420'.'#22791#27880' FROM '#20809#32420' INNER JOIN '#35774#22791#31471#21475' ON ' +
      #20809#32420'.'#20809#32420'ID = '#35774#22791#31471#21475'.'#20809#32420'ID LEFT JOIN '#24320#36890#19994#21153' ON '#20809#32420'.'#20809#32420'ID = '#24320#36890#19994#21153'.'#20809#32420'ID LEFT J' +
      'OIN '#19994#21153' ON '#24320#36890#19994#21153'.'#19994#21153'ID = '#19994#21153'.'#19994#21153'ID INNER JOIN '#21333#20803' ON '#35774#22791#31471#21475'.'#21333#20803'ID = '#21333#20803'.'#21333#20803 +
      'ID INNER JOIN '#35774#22791' ON '#35774#22791'.'#35774#22791'ID = '#21333#20803'.'#35774#22791'ID INNER JOIN '#35774#22791#31471#21475' AS '#35774#22791#31471#21475'2 O' +
      'N '#20809#32420'.'#20809#32420'ID = '#35774#22791#31471#21475'2.'#20809#32420'ID INNER JOIN '#21333#20803' AS '#21333#20803'2 ON '#35774#22791#31471#21475'2.'#21333#20803'ID = '#21333#20803'2.' +
      #21333#20803'ID INNER JOIN '#35774#22791' AS '#35774#22791'2 ON '#35774#22791'2.'#35774#22791'ID = '#21333#20803'2.'#35774#22791'ID JOIN '#20809#32518#23614' ON '#20809#32518#23614 +
      '.'#20809#32518#23614'ID = '#20809#32420'.'#20809#32518#23614'ID JOIN '#20809#32518#22836' ON '#20809#32518#23614'.'#20809#32518#22836'ID = '#20809#32518#22836'.'#20809#32518#22836'ID   WHERE '#20809#32420'.'#20809 +
      #32518#23614'ID = :OCTailID AND '#35774#22791#31471#21475'.'#36215#22987#26631#35760' = '#39#20809#32420#22987#31471#39' AND '#35774#22791#31471#21475'2.'#36215#22987#26631#35760' = '#39#20809#32420#26411#31471#39' ' +
      ' order by '#24207#21495
    Params = <
      item
        DataType = ftInteger
        Name = 'OCTailID'
        ParamType = ptInput
        Value = 0
      end>
    ProviderName = 'pvOF'
    RemoteServer = SocketConn
    OnReconcileError = dsOFReconcileError
    Left = 184
    Top = 64
  end
  object dsTemp: TClientDataSet
    Aggregates = <>
    CommandText = 
      'select count(*) / (select case count(*) when 0 then 1 else count' +
      '(*) end  from '#20809#32420' where '#20809#32518#23614'ID in (select '#20809#32518#23614'ID from '#20809#32518#23614' join '#20809#32518#22836' ' +
      'on '#20809#32518#23614'.'#20809#32518#22836'ID = '#20809#32518#22836'.'#20809#32518#22836'ID where '#20809#32518#23614'.'#32456#31471#22320#22336' like '#39'%'#39' + :TailAddress ' +
      '+ '#39'%'#39' and '#20809#32518#22836'.'#22987#31471#22320#22336' like '#39'%'#39' + :HeaderAddress + '#39'%'#39')) from '#20809#32420' whe' +
      're '#29366#24577' = '#39#21344#29992#39' and '#20809#32518#23614'ID in (select '#20809#32518#23614'ID from '#20809#32518#23614' join '#20809#32518#22836' on '#20809#32518#23614 +
      '.'#20809#32518#22836'ID = '#20809#32518#22836'.'#20809#32518#22836'ID where '#20809#32518#23614'.'#32456#31471#22320#22336' like '#39'%'#39' + :TailAddress + '#39'%'#39' ' +
      'and '#20809#32518#22836'.'#22987#31471#22320#22336' like '#39'%'#39' + :HeaderAddress + '#39'%'#39')'
    Params = <
      item
        DataType = ftUnknown
        Name = 'TailAddress'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'HeaderAddress'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'TailAddress'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'HeaderAddress'
        ParamType = ptUnknown
      end>
    ProviderName = 'pvTemp'
    RemoteServer = SocketConn
    AfterPost = dsOCHeaderAfterPost
    OnReconcileError = dsTempReconcileError
    Left = 264
    Top = 64
  end
  object dsDevices: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#35774#22791
    Params = <>
    ProviderName = 'pvDevices'
    RemoteServer = SocketConn
    AfterPost = dsDevicesAfterPost
    AfterDelete = dsDevicesAfterDelete
    OnReconcileError = dsDevicesReconcileError
    Left = 344
    Top = 64
  end
  object dsDevicePort: TClientDataSet
    Aggregates = <>
    CommandText = 
      'select '#35774#22791#31471#21475'.'#31471#21475'ID,'#20809#32518#23614'.'#20809#32518#23614'ID,'#20809#32518#23614'.'#33455#25968','#35774#22791'.'#22320#22336','#21333#20803'.'#21333#20803#32534#21495','#20809#32420'.'#22791#27880','#35774#22791#31471#21475'.'#31471#21475#21495','#20809 +
      #32420'.'#24207#21495','#19994#21153'.'#19994#21153#21517#31216','#24320#36890#19994#21153'.'#36335#30001#39034#24207','#20809#32420'.'#29366#24577','#20809#32420'.'#25104#31471#24773#20917','#20809#32518#23614'.'#32456#31471#22320#22336','#20809#32518#22836'.'#22987#31471#22320#22336', '#35774#22791#31471#21475'.'#36215#22987#26631 +
      #35760' from '#35774#22791#31471#21475' join '#20809#32420' on '#35774#22791#31471#21475'.'#20809#32420'ID = '#20809#32420'.'#20809#32420'ID left join '#24320#36890#19994#21153' on '#20809#32420'.' +
      #20809#32420'ID = '#24320#36890#19994#21153'.'#20809#32420'ID left join '#19994#21153' on '#19994#21153'.'#19994#21153'ID = '#24320#36890#19994#21153'.'#19994#21153'ID join '#21333#20803' on ' +
      #21333#20803'.'#21333#20803'ID = '#35774#22791#31471#21475'.'#21333#20803'ID join '#35774#22791' on '#21333#20803'.'#35774#22791'ID = '#35774#22791'.'#35774#22791'ID join '#20809#32518#23614' on '#20809#32420'.' +
      #20809#32518#23614'ID = '#20809#32518#23614'.'#20809#32518#23614'ID join '#20809#32518#22836' on '#20809#32518#23614'.'#20809#32518#22836'ID = '#20809#32518#22836'.'#20809#32518#22836'ID where '#35774#22791#31471#21475'.'#21333 +
      #20803'ID = :UnitID order by '#35774#22791#31471#21475'.'#31471#21475#21495
    Params = <
      item
        DataType = ftUnknown
        Name = 'UnitID'
        ParamType = ptUnknown
      end>
    ProviderName = 'pvDevicePort'
    RemoteServer = SocketConn
    OnReconcileError = dsDevicePortReconcileError
    Left = 520
    Top = 64
  end
  object dsUnit: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#21333#20803' where  '#35774#22791'ID =  :DeviceID order by '#21333#20803#32534#21495
    Params = <
      item
        DataType = ftUnknown
        Name = 'DeviceID'
        ParamType = ptUnknown
      end>
    ProviderName = 'pvUnit'
    RemoteServer = SocketConn
    OnReconcileError = dsUnitReconcileError
    Left = 432
    Top = 64
  end
  object dsOCSearch: TClientDataSet
    Aggregates = <>
    CommandText = 
      'select *,((select count(*) from '#20809#32420' where '#20809#32420'.'#20809#32518#23614'ID = A.'#20809#32518#23614'ID and ' +
      #20809#32420'.'#29366#24577' = '#39#39#21344#29992#39#39') / A.'#33455#25968' *100) as '#21344#29992#29575' from '#20809#32518#22836' join '#20809#32518#23614' A on '#20809#32518#22836'.'#20809 +
      #32518#22836'ID = A.'#20809#32518#22836'ID'
    Params = <>
    ProviderName = 'pvOCSearch'
    RemoteServer = SocketConn
    Left = 24
    Top = 120
  end
  object dsBusiness: TClientDataSet
    Aggregates = <>
    CommandText = 
      'SELECT '#20809#32518#22836'.'#22987#31471#22320#22336','#20809#32518#23614'.'#32456#31471#22320#22336','#20809#32420'.'#24207#21495','#20809#32420'.'#29366#24577','#20809#32420'.'#19994#21153#21517#31216','#35774#22791'.'#22320#22336','#35774#22791'.'#35774#22791#31867#22411' As '#22987#31471 +
      #35774#22791#22320#22336','#21333#20803'.'#21333#20803#32534#21495' As '#22987#31471#35774#22791#21333#20803#21495','#35774#22791#31471#21475'.'#31471#21475#21495' As '#22987#31471#35774#22791#31471#21475#20301#32622','#35774#22791'2.'#22320#22336' As '#32456#31471#35774#22791#22320#22336','#35774#22791 +
      '2.'#35774#22791#31867#22411','#21333#20803'2.'#21333#20803#32534#21495' As '#32456#31471#35774#22791#21333#20803#21495','#35774#22791#31471#21475'2.'#31471#21475#21495' As '#32456#31471#35774#22791#31471#21475#20301#32622','#20809#32420'.'#22791#27880' FROM '#20809#32420' I' +
      'NNER JOIN '#35774#22791#31471#21475' ON '#20809#32420'.'#20809#32420'ID = '#35774#22791#31471#21475'.'#20809#32420'ID INNER JOIN '#20809#32518#23614' ON '#20809#32420'.'#20809#32518#23614'ID' +
      ' = '#20809#32518#23614'.'#20809#32518#23614'ID INNER JOIN '#20809#32518#22836' ON '#20809#32518#22836'.'#20809#32518#22836'ID = '#20809#32518#23614'.'#20809#32518#22836'ID INNER JOIN ' +
      #21333#20803' ON '#35774#22791#31471#21475'.'#21333#20803'ID = '#21333#20803'.'#21333#20803'ID INNER JOIN '#35774#22791' ON '#35774#22791'.'#35774#22791'ID = '#21333#20803'.'#35774#22791'ID INN' +
      'ER JOIN '#35774#22791#31471#21475' AS '#35774#22791#31471#21475'2 ON '#20809#32420'.'#20809#32420'ID = '#35774#22791#31471#21475'2.'#20809#32420'ID INNER JOIN '#21333#20803' AS '#21333 +
      #20803'2 ON '#35774#22791#31471#21475'2.'#21333#20803'ID = '#21333#20803'2.'#21333#20803'ID INNER JOIN '#35774#22791' AS '#35774#22791'2 ON '#35774#22791'2.'#35774#22791'ID = '#21333 +
      #20803'2.'#35774#22791'ID WHERE '#35774#22791#31471#21475'.'#36215#22987#26631#35760' = '#39#20809#32420#22987#31471#39' AND '#35774#22791#31471#21475'2.'#36215#22987#26631#35760' = '#39#20809#32420#26411#31471#39' '
    Params = <>
    ProviderName = 'pvBusiness'
    RemoteServer = SocketConn
    Left = 104
    Top = 120
  end
  object dsUserManage: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#29992#25143
    Params = <>
    ProviderName = 'pvUsers'
    RemoteServer = SocketConn
    AfterPost = dsUserManageAfterPost
    AfterDelete = dsUserManageAfterDelete
    Left = 184
    Top = 120
  end
  object dsLog: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#26085#24535
    Params = <>
    ProviderName = 'pvLog'
    RemoteServer = SocketConn
    Left = 264
    Top = 120
  end
  object TempSocketConn: TSocketConnection
    ServerGUID = '{CE2C4A7D-6B08-41FD-A65E-2E7DCB2B02D1}'
    ServerName = 'Server.OCMSServer'
    Left = 104
    Top = 8
  end
  object dsBoundBusiness: TClientDataSet
    Aggregates = <>
    CommandText = 
      'SELECT '#24320#36890#19994#21153'.'#20809#32420'ID,'#24320#36890#19994#21153'.'#19994#21153'ID,'#24320#36890#19994#21153'.'#36335#30001#39034#24207','#20809#32518#22836'.'#22987#31471#22320#22336' AS '#20809#32518#22987#31471#22320#22336','#20809#32518#23614'.'#32456#31471#22320#22336 +
      ' AS '#20809#32518#26411#31471#22320#22336','#20809#32420'.'#24207#21495','#20809#32420'.'#29366#24577','#20809#32420'.'#25104#31471#24773#20917','#35774#22791'.'#22320#22336' As '#22987#31471#35774#22791#22320#22336','#35774#22791'.'#35774#22791#31867#22411','#21333#20803'.'#21333#20803#32534#21495' A' +
      's '#22987#31471#35774#22791#21333#20803#21495','#35774#22791#31471#21475'.'#31471#21475#21495' As '#22987#31471#35774#22791#31471#21475#20301#32622','#35774#22791'2.'#22320#22336' As '#26411#31471#35774#22791#22320#22336','#35774#22791'2.'#35774#22791#31867#22411','#21333#20803'2.'#21333#20803#32534 +
      #21495' As '#26411#31471#35774#22791#21333#20803#21495','#35774#22791#31471#21475'2.'#31471#21475#21495' As '#26411#31471#35774#22791#31471#21475#20301#32622','#20809#32420'.'#22791#27880' FROM '#20809#32420' INNER JOIN '#35774#22791#31471#21475 +
      ' ON '#20809#32420'.'#20809#32420'ID = '#35774#22791#31471#21475'.'#20809#32420'ID INNER JOIN '#24320#36890#19994#21153' ON '#20809#32420'.'#20809#32420'ID = '#24320#36890#19994#21153'.'#20809#32420'ID I' +
      'NNER JOIN '#21333#20803' ON '#35774#22791#31471#21475'.'#21333#20803'ID = '#21333#20803'.'#21333#20803'ID INNER JOIN '#35774#22791' ON '#35774#22791'.'#35774#22791'ID = '#21333 +
      #20803'.'#35774#22791'ID INNER JOIN '#35774#22791#31471#21475' AS '#35774#22791#31471#21475'2 ON '#20809#32420'.'#20809#32420'ID = '#35774#22791#31471#21475'2.'#20809#32420'ID INNER JO' +
      'IN '#21333#20803' AS '#21333#20803'2 ON '#35774#22791#31471#21475'2.'#21333#20803'ID = '#21333#20803'2.'#21333#20803'ID INNER JOIN '#35774#22791' AS '#35774#22791'2 ON '#35774#22791 +
      '2.'#35774#22791'ID = '#21333#20803'2.'#35774#22791'ID JOIN '#20809#32518#23614' ON '#20809#32518#23614'.'#20809#32518#23614'ID = '#20809#32420'.'#20809#32518#23614'ID JOIN '#20809#32518#22836' ON '#20809 +
      #32518#23614'.'#20809#32518#22836'ID = '#20809#32518#22836'.'#20809#32518#22836'ID WHERE '#35774#22791#31471#21475'.'#36215#22987#26631#35760' = '#39#20809#32420#22987#31471#39' AND '#35774#22791#31471#21475'2.'#36215#22987#26631#35760' = '#39 +
      #20809#32420#26411#31471#39' AND '#24320#36890#19994#21153'.'#19994#21153'ID = :BusinessID order by '#36335#30001#39034#24207
    Params = <
      item
        DataType = ftUnknown
        Name = 'BusinessID'
        ParamType = ptUnknown
      end>
    ProviderName = 'pvBoundBusiness'
    RemoteServer = SocketConn
    Left = 344
    Top = 120
  end
  object dsOCType: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#20809#32518#31867#22411
    Params = <>
    ProviderName = 'pvOCType'
    RemoteServer = SocketConn
    BeforePost = dsOCTypeBeforePost
    AfterPost = dsOCTypeAfterPost
    AfterDelete = dsOCTypeAfterDelete
    Left = 432
    Top = 120
  end
  object dsLayType: TClientDataSet
    Aggregates = <>
    CommandText = 'select * from '#25975#35774#26041#24335
    Params = <>
    ProviderName = 'pvLayType'
    RemoteServer = SocketConn
    BeforePost = dsLayTypeBeforePost
    AfterPost = dsLayTypeAfterPost
    AfterDelete = dsLayTypeAfterDelete
    Left = 520
    Top = 120
  end
end
